Tabela PostalCode

Definicja tabeli PostalCode

Name

PostalCode

Code

PostalCode

Comment

Tabela kodów pocztowych


Lista kolumn tabeli PostalCode

Name

Code

PostalCodeID

PostalCodeID

PostalCode

PostalCode

SYM

SYM

TERC

TERC

Street

Street

Buildings

Buildings

Active

Active

PostOfficeName

PostOfficeName


Kolumna PostalCodeID tabeli PostalCode

Definicja kolumny PostalCodeID tabeli PostalCode

Name

PostalCodeID

Code

PostalCodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PostalCode tabeli PostalCode

Definicja kolumny PostalCode tabeli PostalCode

Name

PostalCode

Code

PostalCode

Data Type

VARCHAR2(6)

Mandatory

Yes

Comment

Kod pocztowy


Kolumna SYM tabeli PostalCode

Definicja kolumny SYM tabeli PostalCode

Name

SYM

Code

SYM

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

Identyfikator miejscowosci Place.SYM


Kolumna TERC tabeli PostalCode

Definicja kolumny TERC tabeli PostalCode

Name

TERC

Code

TERC

Data Type

VARCHAR2(13)

Mandatory

Yes

Comment

Identyfikator gminy AdmCodeText.Code


Kolumna Street tabeli PostalCode

Definicja kolumny Street tabeli PostalCode

Name

Street

Code

Street

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa ulicy


Kolumna Buildings tabeli PostalCode

Definicja kolumny Buildings tabeli PostalCode

Name

Buildings

Code

Buildings

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numery budynków w postaci 11-21(n),2-8(p)


Kolumna Active tabeli PostalCode

Definicja kolumny Active tabeli PostalCode

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Kolumna PostOfficeName tabeli PostalCode

Definicja kolumny PostOfficeName tabeli PostalCode

Name

PostOfficeName

Code

PostOfficeName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa placówki poczty. Jesli uzupelniona, oznacza to ze jest to kod pocztowy placówki poczty.


Lista kluczy tabeli PostalCode

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PostalCode

Definicja klucza Identifier_1 tabeli PostalCode

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment